3 -- http://www.phpmyadmin.net
6 -- Generation Time: Aug 21, 2013 at 07:03 AM
7 -- Server version: 5.1.63-community
10 SET FOREIGN_KEY_CHECKS=0;
11 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
12 SET time_zone = "+00:00";
15 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18 /*!40101 SET NAMES utf8 */;
24 -- --------------------------------------------------------
27 -- Table structure for table `auction`
30 DROP TABLE IF EXISTS `auction`;
31 CREATE TABLE IF NOT EXISTS `auction` (
32 `id` int(11) NOT NULL AUTO_INCREMENT,
33 `created_by_profile_id` int(11) NOT NULL,
34 `company_id` int(11) NOT NULL,
35 `stock_id` int(11) NOT NULL,
36 `sold_to_profile_id` int(11) DEFAULT NULL,
37 `sold_to_company_id` int(11) DEFAULT NULL,
38 `auction_bid_id` int(11) DEFAULT NULL,
39 `bid_price` decimal(11,2) NOT NULL,
40 `reserve_price` decimal(11,2) NOT NULL,
41 `bid_increment` decimal(11,2) NOT NULL,
42 `start_date` datetime NOT NULL,
43 `end_date` datetime NOT NULL,
44 `number_of_bids` int(11) NOT NULL,
45 `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
46 `created` datetime NOT NULL,
47 `updated` datetime DEFAULT NULL,
48 `archived` tinyint(1) NOT NULL,
50 UNIQUE KEY `UNIQ_DEE4F593340BCA85` (`auction_bid_id`),
51 KEY `IDX_DEE4F593FFA30A58` (`created_by_profile_id`),
52 KEY `IDX_DEE4F593979B1AD6` (`company_id`),
53 KEY `IDX_DEE4F593DCD6110` (`stock_id`),
54 KEY `IDX_DEE4F5933291555F` (`sold_to_profile_id`),
55 KEY `IDX_DEE4F59369F05D31` (`sold_to_company_id`)
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
58 -- --------------------------------------------------------
61 -- Table structure for table `auction_autobid`
64 DROP TABLE IF EXISTS `auction_autobid`;
65 CREATE TABLE IF NOT EXISTS `auction_autobid` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `auction_id` int(11) NOT NULL,
68 `company_id` int(11) NOT NULL,
69 `profile_id` int(11) NOT NULL,
70 `amount` decimal(11,2) NOT NULL,
71 `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
72 `created` datetime NOT NULL,
73 `archived` tinyint(1) NOT NULL,
75 KEY `IDX_69F7105B57B8F0DE` (`auction_id`),
76 KEY `IDX_69F7105B979B1AD6` (`company_id`),
77 KEY `IDX_69F7105BCCFA12B8` (`profile_id`)
78 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
80 -- --------------------------------------------------------
83 -- Table structure for table `auction_bid`
86 DROP TABLE IF EXISTS `auction_bid`;
87 CREATE TABLE IF NOT EXISTS `auction_bid` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `auction_id` int(11) NOT NULL,
90 `company_id` int(11) NOT NULL,
91 `profile_id` int(11) NOT NULL,
92 `auction_autobid_id` int(11) DEFAULT NULL,
93 `amount` decimal(11,2) NOT NULL,
94 `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
95 `created` datetime NOT NULL,
96 `archived` tinyint(1) NOT NULL,
98 KEY `IDX_401A9C4357B8F0DE` (`auction_id`),
99 KEY `IDX_401A9C43979B1AD6` (`company_id`),
100 KEY `IDX_401A9C43CCFA12B8` (`profile_id`),
101 KEY `IDX_401A9C436FB371E6` (`auction_autobid_id`)
102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
104 -- --------------------------------------------------------
107 -- Table structure for table `auction_increment`
110 DROP TABLE IF EXISTS `auction_increment`;
111 CREATE TABLE IF NOT EXISTS `auction_increment` (
112 `id` int(11) NOT NULL AUTO_INCREMENT,
113 `from` int(10) unsigned NOT NULL,
114 `to` int(10) unsigned NOT NULL,
115 `amount` decimal(11,2) NOT NULL,
117 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
120 -- Dumping data for table `auction_increment`
123 INSERT INTO `auction_increment` (`id`, `from`, `to`, `amount`) VALUES
124 (1, 0, 50000, '500.00'),
125 (2, 50000, 150000, '1000.00'),
126 (3, 150000, 300000, '1500.00'),
127 (4, 300000, 16000000, '2000.00');
130 CREATE TABLE `auction_question` (
131 `id` int(11) NOT NULL AUTO_INCREMENT,
132 `auction_id` int(11) NOT NULL,
133 `company_id` int(11) NOT NULL,
134 `profile_id` int(11) NOT NULL,
135 `auction_reply_id` int(11) DEFAULT NULL,
136 `question` longtext COLLATE utf8_unicode_ci NOT NULL,
137 `created` datetime NOT NULL,
138 `updated` datetime DEFAULT NULL,
139 `archived` tinyint(1) NOT NULL,
141 KEY `IDX_37F97A057B8F0DE` (`auction_id`),
142 KEY `IDX_37F97A0979B1AD6` (`company_id`),
143 KEY `IDX_37F97A0CCFA12B8` (`profile_id`),
144 KEY `IDX_37F97A03F869091` (`auction_reply_id`),
145 CONSTRAINT `FK_37F97A03F869091` FOREIGN KEY (`auction_reply_id`) REFERENCES `auction_reply` (`id`),
146 CONSTRAINT `FK_37F97A057B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
147 CONSTRAINT `FK_37F97A0979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
148 CONSTRAINT `FK_37F97A0CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`)
149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
152 CREATE TABLE `auction_reply` (
153 `id` int(11) NOT NULL AUTO_INCREMENT,
154 `auction_question_id` int(11) NOT NULL,
155 `profile_id` int(11) NOT NULL,
156 `reply` longtext COLLATE utf8_unicode_ci NOT NULL,
157 `archived` tinyint(1) NOT NULL,
159 KEY `IDX_B2BC5FE94183E823` (`auction_question_id`),
160 KEY `IDX_B2BC5FE9CCFA12B8` (`profile_id`),
161 CONSTRAINT `FK_B2BC5FE94183E823` FOREIGN KEY (`auction_question_id`) REFERENCES `auction_question` (`id`),
162 CONSTRAINT `FK_B2BC5FE9CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`)
163 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
165 CREATE TABLE `auction_public_holiday` (
166 `id` int(11) NOT NULL AUTO_INCREMENT,
167 `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
168 `holiday` date NOT NULL,
169 `created` datetime NOT NULL,
170 `updated` datetime DEFAULT NULL,
172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
175 CREATE TABLE `dispute` (
176 `id` int(11) NOT NULL AUTO_INCREMENT,
177 `created_by_profile_id` int(11) NOT NULL,
178 `from_company_id` int(11) NOT NULL,
179 `against_company_id` int(11) NOT NULL,
180 `auction_id` int(11) NOT NULL,
181 `complaint` longtext COLLATE utf8_unicode_ci NOT NULL,
182 `resolution` longtext COLLATE utf8_unicode_ci NOT NULL,
183 `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
184 `created` datetime NOT NULL,
185 `updated` datetime DEFAULT NULL,
186 `archived` tinyint(1) NOT NULL,
188 KEY `IDX_3C925007FFA30A58` (`created_by_profile_id`),
189 KEY `IDX_3C925007BC3FDCD1` (`from_company_id`),
190 KEY `IDX_3C92500767F3FF09` (`against_company_id`),
191 KEY `IDX_3C92500757B8F0DE` (`auction_id`),
192 CONSTRAINT `FK_3C92500757B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
193 CONSTRAINT `FK_3C92500767F3FF09` FOREIGN KEY (`against_company_id`) REFERENCES `company` (`id`),
194 CONSTRAINT `FK_3C925007BC3FDCD1` FOREIGN KEY (`from_company_id`) REFERENCES `company` (`id`),
195 CONSTRAINT `FK_3C925007FFA30A58` FOREIGN KEY (`created_by_profile_id`) REFERENCES `profile` (`id`)
196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
201 CREATE TABLE `auction_basket` (
202 `id` int(11) NOT NULL AUTO_INCREMENT,
203 `auction_id` int(11) NOT NULL,
204 `company_id` int(11) NOT NULL,
205 `profile_id` int(11) NOT NULL,
206 `created` datetime NOT NULL,
207 `updated` datetime DEFAULT NULL,
208 `archived` tinyint(1) NOT NULL,
210 KEY `IDX_5BD5FC4657B8F0DE` (`auction_id`),
211 KEY `IDX_5BD5FC46979B1AD6` (`company_id`),
212 KEY `IDX_5BD5FC46CCFA12B8` (`profile_id`),
213 CONSTRAINT `FK_5BD5FC46CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`),
214 CONSTRAINT `FK_5BD5FC4657B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
215 CONSTRAINT `FK_5BD5FC46979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`)
216 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
222 -- Constraints for dumped tables
226 -- Constraints for table `auction`
228 ALTER TABLE `auction`
229 ADD CONSTRAINT `FK_DEE4F5933291555F` FOREIGN KEY (`sold_to_profile_id`) REFERENCES `profile` (`id`),
230 ADD CONSTRAINT `FK_DEE4F593340BCA85` FOREIGN KEY (`auction_bid_id`) REFERENCES `auction_bid` (`id`),
231 ADD CONSTRAINT `FK_DEE4F59369F05D31` FOREIGN KEY (`sold_to_company_id`) REFERENCES `company` (`id`),
232 ADD CONSTRAINT `FK_DEE4F593979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
233 ADD CONSTRAINT `FK_DEE4F593DCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`),
234 ADD CONSTRAINT `FK_DEE4F593FFA30A58` FOREIGN KEY (`created_by_profile_id`) REFERENCES `profile` (`id`);
237 -- Constraints for table `auction_autobid`
239 ALTER TABLE `auction_autobid`
240 ADD CONSTRAINT `FK_69F7105B57B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
241 ADD CONSTRAINT `FK_69F7105B979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
242 ADD CONSTRAINT `FK_69F7105BCCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`);
245 -- Constraints for table `auction_bid`
247 ALTER TABLE `auction_bid`
248 ADD CONSTRAINT `FK_401A9C4357B8F0DE` FOREIGN KEY (`auction_id`) REFERENCES `auction` (`id`),
249 ADD CONSTRAINT `FK_401A9C436FB371E6` FOREIGN KEY (`auction_autobid_id`) REFERENCES `auction_autobid` (`id`),
250 ADD CONSTRAINT `FK_401A9C43979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
251 ADD CONSTRAINT `FK_401A9C43CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`);
256 ALTER TABLE `mig_db`.`stock` ADD COLUMN `auction_id` INT(11) NULL DEFAULT NULL AFTER `price_guide_id`, ADD COLUMN `times_listed` INT NOT NULL AFTER `loaded_on_priceguide`, ADD COLUMN `highest_bid` DECIMAL(11,2) NOT NULL AFTER `times_listed`;
258 ALTER TABLE `mig_db`.`stock`
259 ADD CONSTRAINT `FK_stockauction`
260 FOREIGN KEY (`auction_id` )
261 REFERENCES `mig_db`.`auction` (`id` )
264 , ADD INDEX `IDX_stockauction` (`auction_id`) ;
267 ALTER TABLE app_config add column `auction_max_days` smallint(6) DEFAULT NULL after price_guide_completion_days;
268 UPDATE app_config set auction_max_days=7;
270 ALTER TABLE `mig_db`.`price_guide_club_member` CHANGE COLUMN `price_guide_allowed_member_id` `price_guide_allowed_member_id` INT(11) NULL DEFAULT NULL;
272 ALTER TABLE `profile_permissions` ADD COLUMN `auction_page` tinyint(1) NOT NULL AFTER `pg_un_archive`, ADD COLUMN `auction_create` tinyint(1) NOT NULL AFTER `auction_page`, ADD COLUMN `auction_bid` tinyint(1) NOT NULL AFTER `auction_create`;
273 ALTER TABLE `profile_permissions` ADD COLUMN `stock_route_auction` tinyint(1) NOT NULL AFTER `stock_view`;
274 alter table profile_permissions add column admin_auction tinyint(1) NOT NULL after admin_user;
276 ALTER TABLE `profile_permissions_override` ADD COLUMN `auction_page` tinyint(1) NOT NULL AFTER `pg_un_archive`, ADD COLUMN `auction_create` tinyint(1) NOT NULL AFTER `auction_page`, ADD COLUMN `auction_bid` tinyint(1) NOT NULL AFTER `auction_create`;
277 ALTER TABLE `profile_permissions_override` ADD COLUMN `stock_route_auction` tinyint(1) NOT NULL AFTER `stock_view`;
278 alter table profile_permissions_override add column admin_auction tinyint(1) NOT NULL after admin_user;
280 ALTER TABLE `mig_db`.`auction_increment` CHANGE COLUMN `from` `range_from` INT(10) UNSIGNED NOT NULL , CHANGE COLUMN `to` `range_to` INT(10) UNSIGNED NOT NULL ;
283 update company set price_guide=0;
284 update company set price_guide=1 where company_group_id in(1,21);
287 SET FOREIGN_KEY_CHECKS=1;
289 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
290 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
291 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;